{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 研究功能简介\n",
    "感谢您使用研究功能~~\n",
    "\n",
    "研究功能基于IPython Notebook，支持灵活的图表处理、数据处理，后续我们还会增加财务数据。\n",
    "\n",
    "研究功能支持导入第三方库，您可以根据需要引入，[查看详情](/api#third_lib)。\n",
    "\n",
    "\n",
    "研究功能提供分钟级数据，采用Docker技术隔离，资源独立、安全性更高、性能更好，同步支持Python2、Python3。\n",
    "\n",
    "# 操作说明\n",
    "![操作说明](https://image.joinquant.com/05b0889027f8dfba804ca53dca6d10ed)\n",
    "\n",
    "**1 使用帮助（只读）**\n",
    "\n",
    "新手指引，常用API示例。 \n",
    "\n",
    "**2 新手指引** \n",
    "\n",
    "研究功能简介，操作说明，常用API示例。 \n",
    "\n",
    "**3 常用操作** \n",
    "\n",
    "- New： \n",
    "\n",
    "    - Text File：新建txt文件（可修改文件后缀名，修改为任意文件类型）； \n",
    "\n",
    "    - Folder：新建文件夹； \n",
    "\n",
    "    - Python 3：新建基于Python 3的notebook。 \n",
    "\n",
    "- Upload： \n",
    "\n",
    "    - 上传文件，文件上传后可以在研究和回测中使用。\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Notebook常用操作\n",
    "\n",
    "* 使用 “Shift+Enter” 运行每个代码块\n",
    "* 使用“?”获取帮助\n",
    "* 使用Tab键补全代码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#使用“?”获取帮助示例，使用“Shift+Enter”运行；\n",
    "get_price?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.DataFrame?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#使用Tab键补全函数名\n",
    "get_"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 研究相关API\n",
    "研究新增如下API\n",
    "* get_price()\n",
    "* get_all_securities()\n",
    "* get_index_stocks()\n",
    "* get_industry_stocks()\n",
    "\n",
    "- get_price - 获取历史数据\n",
    "- get_extras - 获取基金净值/期货结算价等\n",
    "- get_fundamentals - 查询财务数据\n",
    "- get_index_stocks - 获取指数成份股\n",
    "- get_industry_stocks - 获取行业成份股\n",
    "- get_concept_stocks - 获取概念成份股\n",
    "- get_all_securities - 获取所有标的信息\n",
    "- get_security_info - 获取单个标的信息\n",
    "- jqdata.get_all_trade_days - 获取所有交易日\n",
    "- jqdata.get_trade_days - 获取指定范围交易日\n",
    "- jqdata.get_money_flow - 获取资金流信息\n",
    "- [更多详见详见API](/api#获取数据函数)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#导入需要的库\n",
    "import pandas as pd\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>open</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2014-01-02</th>\n",
       "      <td>2.2199</td>\n",
       "      <td>2.2190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-03</th>\n",
       "      <td>2.2096</td>\n",
       "      <td>2.1946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-06</th>\n",
       "      <td>2.1880</td>\n",
       "      <td>2.1421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-07</th>\n",
       "      <td>2.1271</td>\n",
       "      <td>2.1431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-08</th>\n",
       "      <td>2.1431</td>\n",
       "      <td>2.1412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-09</th>\n",
       "      <td>2.1365</td>\n",
       "      <td>2.1281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-10</th>\n",
       "      <td>2.1262</td>\n",
       "      <td>2.1131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-13</th>\n",
       "      <td>2.1131</td>\n",
       "      <td>2.0981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-14</th>\n",
       "      <td>2.0981</td>\n",
       "      <td>2.1121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-15</th>\n",
       "      <td>2.1112</td>\n",
       "      <td>2.1121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-16</th>\n",
       "      <td>2.1084</td>\n",
       "      <td>2.1131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-17</th>\n",
       "      <td>2.1065</td>\n",
       "      <td>2.0831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-20</th>\n",
       "      <td>2.0821</td>\n",
       "      <td>2.0728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-21</th>\n",
       "      <td>2.0785</td>\n",
       "      <td>2.0900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-22</th>\n",
       "      <td>2.0929</td>\n",
       "      <td>2.1475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-23</th>\n",
       "      <td>2.1446</td>\n",
       "      <td>2.1360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-24</th>\n",
       "      <td>2.1284</td>\n",
       "      <td>2.1475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-27</th>\n",
       "      <td>2.1322</td>\n",
       "      <td>2.1197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-28</th>\n",
       "      <td>2.1264</td>\n",
       "      <td>2.1217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-29</th>\n",
       "      <td>2.1274</td>\n",
       "      <td>2.1284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-01-30</th>\n",
       "      <td>2.1245</td>\n",
       "      <td>2.0987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-07</th>\n",
       "      <td>2.0814</td>\n",
       "      <td>2.1121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-10</th>\n",
       "      <td>2.1217</td>\n",
       "      <td>2.1734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-11</th>\n",
       "      <td>2.1695</td>\n",
       "      <td>2.1839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-12</th>\n",
       "      <td>2.1849</td>\n",
       "      <td>2.1877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-13</th>\n",
       "      <td>2.1830</td>\n",
       "      <td>2.1820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-14</th>\n",
       "      <td>2.1839</td>\n",
       "      <td>2.1897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-17</th>\n",
       "      <td>2.2107</td>\n",
       "      <td>2.2050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-18</th>\n",
       "      <td>2.2059</td>\n",
       "      <td>2.1791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-02-19</th>\n",
       "      <td>2.1772</td>\n",
       "      <td>2.2079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-18</th>\n",
       "      <td>3.2471</td>\n",
       "      <td>3.2414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-19</th>\n",
       "      <td>3.2443</td>\n",
       "      <td>3.2893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-22</th>\n",
       "      <td>3.2893</td>\n",
       "      <td>3.2663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-23</th>\n",
       "      <td>3.2423</td>\n",
       "      <td>3.2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-24</th>\n",
       "      <td>3.2002</td>\n",
       "      <td>3.1111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-25</th>\n",
       "      <td>3.1303</td>\n",
       "      <td>3.2241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-26</th>\n",
       "      <td>3.2261</td>\n",
       "      <td>3.3496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-29</th>\n",
       "      <td>3.4195</td>\n",
       "      <td>3.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-30</th>\n",
       "      <td>3.3362</td>\n",
       "      <td>3.3333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-31</th>\n",
       "      <td>3.3410</td>\n",
       "      <td>3.4234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>3.4521</td>\n",
       "      <td>3.5326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-06</th>\n",
       "      <td>3.5105</td>\n",
       "      <td>3.5086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-07</th>\n",
       "      <td>3.4914</td>\n",
       "      <td>3.5077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-08</th>\n",
       "      <td>3.5172</td>\n",
       "      <td>3.4310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-09</th>\n",
       "      <td>3.4215</td>\n",
       "      <td>3.4061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-12</th>\n",
       "      <td>3.4071</td>\n",
       "      <td>3.3956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-13</th>\n",
       "      <td>3.3927</td>\n",
       "      <td>3.3889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-14</th>\n",
       "      <td>3.3956</td>\n",
       "      <td>3.3812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-15</th>\n",
       "      <td>3.3812</td>\n",
       "      <td>3.4770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-16</th>\n",
       "      <td>3.4895</td>\n",
       "      <td>3.5077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-19</th>\n",
       "      <td>3.3228</td>\n",
       "      <td>3.1571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-20</th>\n",
       "      <td>3.2045</td>\n",
       "      <td>3.2742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-21</th>\n",
       "      <td>3.2858</td>\n",
       "      <td>3.4242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-22</th>\n",
       "      <td>3.4300</td>\n",
       "      <td>3.4300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-23</th>\n",
       "      <td>3.4542</td>\n",
       "      <td>3.4465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-26</th>\n",
       "      <td>3.4659</td>\n",
       "      <td>3.4794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-27</th>\n",
       "      <td>3.4871</td>\n",
       "      <td>3.4446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-28</th>\n",
       "      <td>3.4184</td>\n",
       "      <td>3.3894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-29</th>\n",
       "      <td>3.3448</td>\n",
       "      <td>3.3535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-30</th>\n",
       "      <td>3.3729</td>\n",
       "      <td>3.3119</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>265 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              open   close\n",
       "2014-01-02  2.2199  2.2190\n",
       "2014-01-03  2.2096  2.1946\n",
       "2014-01-06  2.1880  2.1421\n",
       "2014-01-07  2.1271  2.1431\n",
       "2014-01-08  2.1431  2.1412\n",
       "2014-01-09  2.1365  2.1281\n",
       "2014-01-10  2.1262  2.1131\n",
       "2014-01-13  2.1131  2.0981\n",
       "2014-01-14  2.0981  2.1121\n",
       "2014-01-15  2.1112  2.1121\n",
       "2014-01-16  2.1084  2.1131\n",
       "2014-01-17  2.1065  2.0831\n",
       "2014-01-20  2.0821  2.0728\n",
       "2014-01-21  2.0785  2.0900\n",
       "2014-01-22  2.0929  2.1475\n",
       "2014-01-23  2.1446  2.1360\n",
       "2014-01-24  2.1284  2.1475\n",
       "2014-01-27  2.1322  2.1197\n",
       "2014-01-28  2.1264  2.1217\n",
       "2014-01-29  2.1274  2.1284\n",
       "2014-01-30  2.1245  2.0987\n",
       "2014-02-07  2.0814  2.1121\n",
       "2014-02-10  2.1217  2.1734\n",
       "2014-02-11  2.1695  2.1839\n",
       "2014-02-12  2.1849  2.1877\n",
       "2014-02-13  2.1830  2.1820\n",
       "2014-02-14  2.1839  2.1897\n",
       "2014-02-17  2.2107  2.2050\n",
       "2014-02-18  2.2059  2.1791\n",
       "2014-02-19  2.1772  2.2079\n",
       "...            ...     ...\n",
       "2014-12-18  3.2471  3.2414\n",
       "2014-12-19  3.2443  3.2893\n",
       "2014-12-22  3.2893  3.2663\n",
       "2014-12-23  3.2423  3.2002\n",
       "2014-12-24  3.2002  3.1111\n",
       "2014-12-25  3.1303  3.2241\n",
       "2014-12-26  3.2261  3.3496\n",
       "2014-12-29  3.4195  3.3333\n",
       "2014-12-30  3.3362  3.3333\n",
       "2014-12-31  3.3410  3.4234\n",
       "2015-01-05  3.4521  3.5326\n",
       "2015-01-06  3.5105  3.5086\n",
       "2015-01-07  3.4914  3.5077\n",
       "2015-01-08  3.5172  3.4310\n",
       "2015-01-09  3.4215  3.4061\n",
       "2015-01-12  3.4071  3.3956\n",
       "2015-01-13  3.3927  3.3889\n",
       "2015-01-14  3.3956  3.3812\n",
       "2015-01-15  3.3812  3.4770\n",
       "2015-01-16  3.4895  3.5077\n",
       "2015-01-19  3.3228  3.1571\n",
       "2015-01-20  3.2045  3.2742\n",
       "2015-01-21  3.2858  3.4242\n",
       "2015-01-22  3.4300  3.4300\n",
       "2015-01-23  3.4542  3.4465\n",
       "2015-01-26  3.4659  3.4794\n",
       "2015-01-27  3.4871  3.4446\n",
       "2015-01-28  3.4184  3.3894\n",
       "2015-01-29  3.3448  3.3535\n",
       "2015-01-30  3.3729  3.3119\n",
       "\n",
       "[265 rows x 2 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取股票510300.XSHG2015年1月的日级交易数据\n",
    "df = get_price('510300.XSHG', start_date='2019-01-01', end_date='2019-01-31', frequency='daily', fields=['open','close']) \n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>display_name</th>\n",
       "      <th>name</th>\n",
       "      <th>start_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>000001.XSHE</th>\n",
       "      <td>平安银行</td>\n",
       "      <td>PAYH</td>\n",
       "      <td>1991-04-03</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000002.XSHE</th>\n",
       "      <td>万  科Ａ</td>\n",
       "      <td>WKA</td>\n",
       "      <td>1991-01-29</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000004.XSHE</th>\n",
       "      <td>国农科技</td>\n",
       "      <td>GNKJ</td>\n",
       "      <td>1990-12-01</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000005.XSHE</th>\n",
       "      <td>世纪星源</td>\n",
       "      <td>SJXY</td>\n",
       "      <td>1990-12-10</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000006.XSHE</th>\n",
       "      <td>深振业Ａ</td>\n",
       "      <td>SZYA</td>\n",
       "      <td>1992-04-27</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000007.XSHE</th>\n",
       "      <td>全新好</td>\n",
       "      <td>QXH</td>\n",
       "      <td>1992-04-13</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000008.XSHE</th>\n",
       "      <td>神州高铁</td>\n",
       "      <td>SZGT</td>\n",
       "      <td>1992-05-07</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000009.XSHE</th>\n",
       "      <td>中国宝安</td>\n",
       "      <td>ZGBA</td>\n",
       "      <td>1991-06-25</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000010.XSHE</th>\n",
       "      <td>美丽生态</td>\n",
       "      <td>SHX</td>\n",
       "      <td>1995-10-27</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000011.XSHE</th>\n",
       "      <td>深物业A</td>\n",
       "      <td>SWYA</td>\n",
       "      <td>1992-03-30</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000012.XSHE</th>\n",
       "      <td>南  玻Ａ</td>\n",
       "      <td>NBA</td>\n",
       "      <td>1992-02-28</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000014.XSHE</th>\n",
       "      <td>沙河股份</td>\n",
       "      <td>SHGF</td>\n",
       "      <td>1992-06-02</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000016.XSHE</th>\n",
       "      <td>深康佳Ａ</td>\n",
       "      <td>SKJA</td>\n",
       "      <td>1992-03-27</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000017.XSHE</th>\n",
       "      <td>深中华A</td>\n",
       "      <td>SZHA</td>\n",
       "      <td>1992-03-31</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000018.XSHE</th>\n",
       "      <td>神州长城</td>\n",
       "      <td>SZCC</td>\n",
       "      <td>1992-06-16</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000019.XSHE</th>\n",
       "      <td>深深宝Ａ</td>\n",
       "      <td>SSBA</td>\n",
       "      <td>1992-10-12</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000020.XSHE</th>\n",
       "      <td>深华发Ａ</td>\n",
       "      <td>SHFA</td>\n",
       "      <td>1992-04-28</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000021.XSHE</th>\n",
       "      <td>深科技</td>\n",
       "      <td>SKJ</td>\n",
       "      <td>1994-02-02</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000022.XSHE</th>\n",
       "      <td>深赤湾Ａ</td>\n",
       "      <td>SCWA</td>\n",
       "      <td>1993-05-05</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000023.XSHE</th>\n",
       "      <td>深天地Ａ</td>\n",
       "      <td>STDA</td>\n",
       "      <td>1993-04-29</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000024.XSHE</th>\n",
       "      <td>招商地产</td>\n",
       "      <td>ZSDC</td>\n",
       "      <td>1993-06-07</td>\n",
       "      <td>2015-12-30</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000025.XSHE</th>\n",
       "      <td>特  力Ａ</td>\n",
       "      <td>TLA</td>\n",
       "      <td>1993-06-21</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000026.XSHE</th>\n",
       "      <td>飞亚达Ａ</td>\n",
       "      <td>FYDA</td>\n",
       "      <td>1993-06-03</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000027.XSHE</th>\n",
       "      <td>深圳能源</td>\n",
       "      <td>SZNY</td>\n",
       "      <td>1993-09-03</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000028.XSHE</th>\n",
       "      <td>国药一致</td>\n",
       "      <td>GYYZ</td>\n",
       "      <td>1993-08-09</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000029.XSHE</th>\n",
       "      <td>深深房Ａ</td>\n",
       "      <td>SSFA</td>\n",
       "      <td>1993-09-15</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000030.XSHE</th>\n",
       "      <td>富奥股份</td>\n",
       "      <td>FAGF</td>\n",
       "      <td>1993-09-29</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000031.XSHE</th>\n",
       "      <td>中粮地产</td>\n",
       "      <td>ZLDC</td>\n",
       "      <td>1993-10-08</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000032.XSHE</th>\n",
       "      <td>深桑达Ａ</td>\n",
       "      <td>SSDA</td>\n",
       "      <td>1993-10-28</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000033.XSHE</th>\n",
       "      <td>*ST新都</td>\n",
       "      <td>STXD</td>\n",
       "      <td>1994-01-03</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603906.XSHG</th>\n",
       "      <td>龙蟠科技</td>\n",
       "      <td>LPKJ</td>\n",
       "      <td>2017-04-10</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603908.XSHG</th>\n",
       "      <td>牧高笛</td>\n",
       "      <td>mgd</td>\n",
       "      <td>2017-03-07</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603909.XSHG</th>\n",
       "      <td>合诚股份</td>\n",
       "      <td>HCGF</td>\n",
       "      <td>2016-06-28</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603918.XSHG</th>\n",
       "      <td>金桥信息</td>\n",
       "      <td>JQXX</td>\n",
       "      <td>2015-05-28</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603919.XSHG</th>\n",
       "      <td>金徽酒</td>\n",
       "      <td>JHJ</td>\n",
       "      <td>2016-03-10</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603920.XSHG</th>\n",
       "      <td>世运电路</td>\n",
       "      <td>SYDL</td>\n",
       "      <td>2017-04-26</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603928.XSHG</th>\n",
       "      <td>兴业股份</td>\n",
       "      <td>XYGF</td>\n",
       "      <td>2016-12-12</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603929.XSHG</th>\n",
       "      <td>亚翔集成</td>\n",
       "      <td>YXJC</td>\n",
       "      <td>2016-12-30</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603936.XSHG</th>\n",
       "      <td>博敏电子</td>\n",
       "      <td>BMDZ</td>\n",
       "      <td>2015-12-09</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603939.XSHG</th>\n",
       "      <td>益丰药房</td>\n",
       "      <td>YFYF</td>\n",
       "      <td>2015-02-17</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603955.XSHG</th>\n",
       "      <td>大千生态</td>\n",
       "      <td>dqst</td>\n",
       "      <td>2017-03-10</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603958.XSHG</th>\n",
       "      <td>哈森股份</td>\n",
       "      <td>HSGF</td>\n",
       "      <td>2016-06-29</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603959.XSHG</th>\n",
       "      <td>百利科技</td>\n",
       "      <td>BLKJ</td>\n",
       "      <td>2016-05-17</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603960.XSHG</th>\n",
       "      <td>克来机电</td>\n",
       "      <td>kljd</td>\n",
       "      <td>2017-03-14</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603966.XSHG</th>\n",
       "      <td>法兰泰克</td>\n",
       "      <td>FLTK</td>\n",
       "      <td>2017-01-25</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603968.XSHG</th>\n",
       "      <td>醋化股份</td>\n",
       "      <td>CHGF</td>\n",
       "      <td>2015-05-18</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603969.XSHG</th>\n",
       "      <td>银龙股份</td>\n",
       "      <td>YLGF</td>\n",
       "      <td>2015-02-27</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603977.XSHG</th>\n",
       "      <td>国泰集团</td>\n",
       "      <td>GTJT</td>\n",
       "      <td>2016-11-11</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603979.XSHG</th>\n",
       "      <td>金诚信</td>\n",
       "      <td>JCX</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603986.XSHG</th>\n",
       "      <td>兆易创新</td>\n",
       "      <td>ZYCX</td>\n",
       "      <td>2016-08-18</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603987.XSHG</th>\n",
       "      <td>康德莱</td>\n",
       "      <td>KDL</td>\n",
       "      <td>2016-11-21</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603988.XSHG</th>\n",
       "      <td>中电电机</td>\n",
       "      <td>ZDDJ</td>\n",
       "      <td>2014-11-04</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603989.XSHG</th>\n",
       "      <td>艾华集团</td>\n",
       "      <td>AHJT</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603990.XSHG</th>\n",
       "      <td>麦迪科技</td>\n",
       "      <td>MDKJ</td>\n",
       "      <td>2016-12-08</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603991.XSHG</th>\n",
       "      <td>至正股份</td>\n",
       "      <td>zzgf</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603993.XSHG</th>\n",
       "      <td>洛阳钼业</td>\n",
       "      <td>LYMY</td>\n",
       "      <td>2012-10-09</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603996.XSHG</th>\n",
       "      <td>中新科技</td>\n",
       "      <td>ZXKJ</td>\n",
       "      <td>2015-12-22</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603997.XSHG</th>\n",
       "      <td>继峰股份</td>\n",
       "      <td>JFGF</td>\n",
       "      <td>2015-03-02</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603998.XSHG</th>\n",
       "      <td>方盛制药</td>\n",
       "      <td>FSZY</td>\n",
       "      <td>2014-12-05</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603999.XSHG</th>\n",
       "      <td>读者传媒</td>\n",
       "      <td>DZCM</td>\n",
       "      <td>2015-12-10</td>\n",
       "      <td>2200-01-01</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3272 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            display_name  name start_date   end_date   type\n",
       "000001.XSHE         平安银行  PAYH 1991-04-03 2200-01-01  stock\n",
       "000002.XSHE        万  科Ａ   WKA 1991-01-29 2200-01-01  stock\n",
       "000004.XSHE         国农科技  GNKJ 1990-12-01 2200-01-01  stock\n",
       "000005.XSHE         世纪星源  SJXY 1990-12-10 2200-01-01  stock\n",
       "000006.XSHE         深振业Ａ  SZYA 1992-04-27 2200-01-01  stock\n",
       "000007.XSHE          全新好   QXH 1992-04-13 2200-01-01  stock\n",
       "000008.XSHE         神州高铁  SZGT 1992-05-07 2200-01-01  stock\n",
       "000009.XSHE         中国宝安  ZGBA 1991-06-25 2200-01-01  stock\n",
       "000010.XSHE         美丽生态   SHX 1995-10-27 2200-01-01  stock\n",
       "000011.XSHE         深物业A  SWYA 1992-03-30 2200-01-01  stock\n",
       "000012.XSHE        南  玻Ａ   NBA 1992-02-28 2200-01-01  stock\n",
       "000014.XSHE         沙河股份  SHGF 1992-06-02 2200-01-01  stock\n",
       "000016.XSHE         深康佳Ａ  SKJA 1992-03-27 2200-01-01  stock\n",
       "000017.XSHE         深中华A  SZHA 1992-03-31 2200-01-01  stock\n",
       "000018.XSHE         神州长城  SZCC 1992-06-16 2200-01-01  stock\n",
       "000019.XSHE         深深宝Ａ  SSBA 1992-10-12 2200-01-01  stock\n",
       "000020.XSHE         深华发Ａ  SHFA 1992-04-28 2200-01-01  stock\n",
       "000021.XSHE          深科技   SKJ 1994-02-02 2200-01-01  stock\n",
       "000022.XSHE         深赤湾Ａ  SCWA 1993-05-05 2200-01-01  stock\n",
       "000023.XSHE         深天地Ａ  STDA 1993-04-29 2200-01-01  stock\n",
       "000024.XSHE         招商地产  ZSDC 1993-06-07 2015-12-30  stock\n",
       "000025.XSHE        特  力Ａ   TLA 1993-06-21 2200-01-01  stock\n",
       "000026.XSHE         飞亚达Ａ  FYDA 1993-06-03 2200-01-01  stock\n",
       "000027.XSHE         深圳能源  SZNY 1993-09-03 2200-01-01  stock\n",
       "000028.XSHE         国药一致  GYYZ 1993-08-09 2200-01-01  stock\n",
       "000029.XSHE         深深房Ａ  SSFA 1993-09-15 2200-01-01  stock\n",
       "000030.XSHE         富奥股份  FAGF 1993-09-29 2200-01-01  stock\n",
       "000031.XSHE         中粮地产  ZLDC 1993-10-08 2200-01-01  stock\n",
       "000032.XSHE         深桑达Ａ  SSDA 1993-10-28 2200-01-01  stock\n",
       "000033.XSHE        *ST新都  STXD 1994-01-03 2200-01-01  stock\n",
       "...                  ...   ...        ...        ...    ...\n",
       "603906.XSHG         龙蟠科技  LPKJ 2017-04-10 2200-01-01  stock\n",
       "603908.XSHG          牧高笛   mgd 2017-03-07 2200-01-01  stock\n",
       "603909.XSHG         合诚股份  HCGF 2016-06-28 2200-01-01  stock\n",
       "603918.XSHG         金桥信息  JQXX 2015-05-28 2200-01-01  stock\n",
       "603919.XSHG          金徽酒   JHJ 2016-03-10 2200-01-01  stock\n",
       "603920.XSHG         世运电路  SYDL 2017-04-26 2200-01-01  stock\n",
       "603928.XSHG         兴业股份  XYGF 2016-12-12 2200-01-01  stock\n",
       "603929.XSHG         亚翔集成  YXJC 2016-12-30 2200-01-01  stock\n",
       "603936.XSHG         博敏电子  BMDZ 2015-12-09 2200-01-01  stock\n",
       "603939.XSHG         益丰药房  YFYF 2015-02-17 2200-01-01  stock\n",
       "603955.XSHG         大千生态  dqst 2017-03-10 2200-01-01  stock\n",
       "603958.XSHG         哈森股份  HSGF 2016-06-29 2200-01-01  stock\n",
       "603959.XSHG         百利科技  BLKJ 2016-05-17 2200-01-01  stock\n",
       "603960.XSHG         克来机电  kljd 2017-03-14 2200-01-01  stock\n",
       "603966.XSHG         法兰泰克  FLTK 2017-01-25 2200-01-01  stock\n",
       "603968.XSHG         醋化股份  CHGF 2015-05-18 2200-01-01  stock\n",
       "603969.XSHG         银龙股份  YLGF 2015-02-27 2200-01-01  stock\n",
       "603977.XSHG         国泰集团  GTJT 2016-11-11 2200-01-01  stock\n",
       "603979.XSHG          金诚信   JCX 2015-06-30 2200-01-01  stock\n",
       "603986.XSHG         兆易创新  ZYCX 2016-08-18 2200-01-01  stock\n",
       "603987.XSHG          康德莱   KDL 2016-11-21 2200-01-01  stock\n",
       "603988.XSHG         中电电机  ZDDJ 2014-11-04 2200-01-01  stock\n",
       "603989.XSHG         艾华集团  AHJT 2015-05-15 2200-01-01  stock\n",
       "603990.XSHG         麦迪科技  MDKJ 2016-12-08 2200-01-01  stock\n",
       "603991.XSHG         至正股份  zzgf 2017-03-08 2200-01-01  stock\n",
       "603993.XSHG         洛阳钼业  LYMY 2012-10-09 2200-01-01  stock\n",
       "603996.XSHG         中新科技  ZXKJ 2015-12-22 2200-01-01  stock\n",
       "603997.XSHG         继峰股份  JFGF 2015-03-02 2200-01-01  stock\n",
       "603998.XSHG         方盛制药  FSZY 2014-12-05 2200-01-01  stock\n",
       "603999.XSHG         读者传媒  DZCM 2015-12-10 2200-01-01  stock\n",
       "\n",
       "[3272 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取平台支持的所有股票, ETF基金信息\n",
    "get_all_securities()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[u'000001.XSHE',\n",
       " u'000002.XSHE',\n",
       " u'000008.XSHE',\n",
       " u'000009.XSHE',\n",
       " u'000027.XSHE',\n",
       " u'000039.XSHE',\n",
       " u'000060.XSHE',\n",
       " u'000061.XSHE',\n",
       " u'000063.XSHE',\n",
       " u'000069.XSHE',\n",
       " u'000100.XSHE',\n",
       " u'000156.XSHE',\n",
       " u'000157.XSHE',\n",
       " u'000166.XSHE',\n",
       " u'000333.XSHE',\n",
       " u'000338.XSHE',\n",
       " u'000402.XSHE',\n",
       " u'000413.XSHE',\n",
       " u'000415.XSHE',\n",
       " u'000423.XSHE',\n",
       " u'000425.XSHE',\n",
       " u'000503.XSHE',\n",
       " u'000538.XSHE',\n",
       " u'000540.XSHE',\n",
       " u'000555.XSHE',\n",
       " u'000559.XSHE',\n",
       " u'000568.XSHE',\n",
       " u'000623.XSHE',\n",
       " u'000625.XSHE',\n",
       " u'000627.XSHE',\n",
       " u'000630.XSHE',\n",
       " u'000651.XSHE',\n",
       " u'000671.XSHE',\n",
       " u'000686.XSHE',\n",
       " u'000709.XSHE',\n",
       " u'000712.XSHE',\n",
       " u'000718.XSHE',\n",
       " u'000725.XSHE',\n",
       " u'000728.XSHE',\n",
       " u'000738.XSHE',\n",
       " u'000750.XSHE',\n",
       " u'000768.XSHE',\n",
       " u'000776.XSHE',\n",
       " u'000778.XSHE',\n",
       " u'000783.XSHE',\n",
       " u'000792.XSHE',\n",
       " u'000793.XSHE',\n",
       " u'000800.XSHE',\n",
       " u'000826.XSHE',\n",
       " u'000839.XSHE',\n",
       " u'000858.XSHE',\n",
       " u'000876.XSHE',\n",
       " u'000895.XSHE',\n",
       " u'000917.XSHE',\n",
       " u'000938.XSHE',\n",
       " u'000963.XSHE',\n",
       " u'000977.XSHE',\n",
       " u'000983.XSHE',\n",
       " u'001979.XSHE',\n",
       " u'002007.XSHE',\n",
       " u'002008.XSHE',\n",
       " u'002024.XSHE',\n",
       " u'002027.XSHE',\n",
       " u'002049.XSHE',\n",
       " u'002065.XSHE',\n",
       " u'002074.XSHE',\n",
       " u'002081.XSHE',\n",
       " u'002085.XSHE',\n",
       " u'002129.XSHE',\n",
       " u'002131.XSHE',\n",
       " u'002142.XSHE',\n",
       " u'002146.XSHE',\n",
       " u'002152.XSHE',\n",
       " u'002153.XSHE',\n",
       " u'002174.XSHE',\n",
       " u'002183.XSHE',\n",
       " u'002195.XSHE',\n",
       " u'002202.XSHE',\n",
       " u'002230.XSHE',\n",
       " u'002236.XSHE',\n",
       " u'002241.XSHE',\n",
       " u'002252.XSHE',\n",
       " u'002292.XSHE',\n",
       " u'002299.XSHE',\n",
       " u'002304.XSHE',\n",
       " u'002310.XSHE',\n",
       " u'002385.XSHE',\n",
       " u'002415.XSHE',\n",
       " u'002424.XSHE',\n",
       " u'002426.XSHE',\n",
       " u'002450.XSHE',\n",
       " u'002456.XSHE',\n",
       " u'002465.XSHE',\n",
       " u'002466.XSHE',\n",
       " u'002470.XSHE',\n",
       " u'002475.XSHE',\n",
       " u'002500.XSHE',\n",
       " u'002568.XSHE',\n",
       " u'002594.XSHE',\n",
       " u'002673.XSHE',\n",
       " u'002714.XSHE',\n",
       " u'002736.XSHE',\n",
       " u'002739.XSHE',\n",
       " u'002797.XSHE',\n",
       " u'300002.XSHE',\n",
       " u'300015.XSHE',\n",
       " u'300017.XSHE',\n",
       " u'300024.XSHE',\n",
       " u'300027.XSHE',\n",
       " u'300033.XSHE',\n",
       " u'300058.XSHE',\n",
       " u'300059.XSHE',\n",
       " u'300070.XSHE',\n",
       " u'300072.XSHE',\n",
       " u'300085.XSHE',\n",
       " u'300104.XSHE',\n",
       " u'300124.XSHE',\n",
       " u'300133.XSHE',\n",
       " u'300144.XSHE',\n",
       " u'300146.XSHE',\n",
       " u'300168.XSHE',\n",
       " u'300182.XSHE',\n",
       " u'300251.XSHE',\n",
       " u'300315.XSHE',\n",
       " u'600000.XSHG',\n",
       " u'600008.XSHG',\n",
       " u'600009.XSHG',\n",
       " u'600010.XSHG',\n",
       " u'600015.XSHG',\n",
       " u'600016.XSHG',\n",
       " u'600018.XSHG',\n",
       " u'600019.XSHG',\n",
       " u'600021.XSHG',\n",
       " u'600023.XSHG',\n",
       " u'600028.XSHG',\n",
       " u'600029.XSHG',\n",
       " u'600030.XSHG',\n",
       " u'600031.XSHG',\n",
       " u'600036.XSHG',\n",
       " u'600037.XSHG',\n",
       " u'600038.XSHG',\n",
       " u'600048.XSHG',\n",
       " u'600050.XSHG',\n",
       " u'600060.XSHG',\n",
       " u'600061.XSHG',\n",
       " u'600066.XSHG',\n",
       " u'600068.XSHG',\n",
       " u'600074.XSHG',\n",
       " u'600085.XSHG',\n",
       " u'600089.XSHG',\n",
       " u'600100.XSHG',\n",
       " u'600104.XSHG',\n",
       " u'600109.XSHG',\n",
       " u'600111.XSHG',\n",
       " u'600115.XSHG',\n",
       " u'600118.XSHG',\n",
       " u'600150.XSHG',\n",
       " u'600153.XSHG',\n",
       " u'600157.XSHG',\n",
       " u'600170.XSHG',\n",
       " u'600177.XSHG',\n",
       " u'600188.XSHG',\n",
       " u'600196.XSHG',\n",
       " u'600208.XSHG',\n",
       " u'600221.XSHG',\n",
       " u'600252.XSHG',\n",
       " u'600256.XSHG',\n",
       " u'600271.XSHG',\n",
       " u'600276.XSHG',\n",
       " u'600297.XSHG',\n",
       " u'600309.XSHG',\n",
       " u'600332.XSHG',\n",
       " u'600340.XSHG',\n",
       " u'600352.XSHG',\n",
       " u'600362.XSHG',\n",
       " u'600369.XSHG',\n",
       " u'600372.XSHG',\n",
       " u'600373.XSHG',\n",
       " u'600376.XSHG',\n",
       " u'600383.XSHG',\n",
       " u'600406.XSHG',\n",
       " u'600415.XSHG',\n",
       " u'600446.XSHG',\n",
       " u'600482.XSHG',\n",
       " u'600485.XSHG',\n",
       " u'600489.XSHG',\n",
       " u'600498.XSHG',\n",
       " u'600518.XSHG',\n",
       " u'600519.XSHG',\n",
       " u'600535.XSHG',\n",
       " u'600547.XSHG',\n",
       " u'600549.XSHG',\n",
       " u'600570.XSHG',\n",
       " u'600582.XSHG',\n",
       " u'600583.XSHG',\n",
       " u'600585.XSHG',\n",
       " u'600588.XSHG',\n",
       " u'600606.XSHG',\n",
       " u'600637.XSHG',\n",
       " u'600648.XSHG',\n",
       " u'600649.XSHG',\n",
       " u'600654.XSHG',\n",
       " u'600660.XSHG',\n",
       " u'600663.XSHG',\n",
       " u'600666.XSHG',\n",
       " u'600674.XSHG',\n",
       " u'600685.XSHG',\n",
       " u'600688.XSHG',\n",
       " u'600690.XSHG',\n",
       " u'600703.XSHG',\n",
       " u'600704.XSHG',\n",
       " u'600705.XSHG',\n",
       " u'600718.XSHG',\n",
       " u'600737.XSHG',\n",
       " u'600739.XSHG',\n",
       " u'600741.XSHG',\n",
       " u'600754.XSHG',\n",
       " u'600783.XSHG',\n",
       " u'600795.XSHG',\n",
       " u'600804.XSHG',\n",
       " u'600816.XSHG',\n",
       " u'600820.XSHG',\n",
       " u'600827.XSHG',\n",
       " u'600837.XSHG',\n",
       " u'600839.XSHG',\n",
       " u'600867.XSHG',\n",
       " u'600871.XSHG',\n",
       " u'600873.XSHG',\n",
       " u'600875.XSHG',\n",
       " u'600886.XSHG',\n",
       " u'600887.XSHG',\n",
       " u'600893.XSHG',\n",
       " u'600895.XSHG',\n",
       " u'600900.XSHG',\n",
       " u'600958.XSHG',\n",
       " u'600959.XSHG',\n",
       " u'600999.XSHG',\n",
       " u'601006.XSHG',\n",
       " u'601009.XSHG',\n",
       " u'601018.XSHG',\n",
       " u'601021.XSHG',\n",
       " u'601088.XSHG',\n",
       " u'601099.XSHG',\n",
       " u'601111.XSHG',\n",
       " u'601118.XSHG',\n",
       " u'601127.XSHG',\n",
       " u'601155.XSHG',\n",
       " u'601166.XSHG',\n",
       " u'601169.XSHG',\n",
       " u'601186.XSHG',\n",
       " u'601198.XSHG',\n",
       " u'601211.XSHG',\n",
       " u'601216.XSHG',\n",
       " u'601225.XSHG',\n",
       " u'601258.XSHG',\n",
       " u'601288.XSHG',\n",
       " u'601318.XSHG',\n",
       " u'601328.XSHG',\n",
       " u'601333.XSHG',\n",
       " u'601336.XSHG',\n",
       " u'601377.XSHG',\n",
       " u'601390.XSHG',\n",
       " u'601398.XSHG',\n",
       " u'601555.XSHG',\n",
       " u'601600.XSHG',\n",
       " u'601601.XSHG',\n",
       " u'601607.XSHG',\n",
       " u'601608.XSHG',\n",
       " u'601611.XSHG',\n",
       " u'601618.XSHG',\n",
       " u'601628.XSHG',\n",
       " u'601633.XSHG',\n",
       " u'601668.XSHG',\n",
       " u'601669.XSHG',\n",
       " u'601688.XSHG',\n",
       " u'601718.XSHG',\n",
       " u'601727.XSHG',\n",
       " u'601766.XSHG',\n",
       " u'601788.XSHG',\n",
       " u'601800.XSHG',\n",
       " u'601818.XSHG',\n",
       " u'601857.XSHG',\n",
       " u'601866.XSHG',\n",
       " u'601872.XSHG',\n",
       " u'601877.XSHG',\n",
       " u'601888.XSHG',\n",
       " u'601899.XSHG',\n",
       " u'601901.XSHG',\n",
       " u'601919.XSHG',\n",
       " u'601928.XSHG',\n",
       " u'601933.XSHG',\n",
       " u'601939.XSHG',\n",
       " u'601958.XSHG',\n",
       " u'601985.XSHG',\n",
       " u'601988.XSHG',\n",
       " u'601989.XSHG',\n",
       " u'601998.XSHG',\n",
       " u'603000.XSHG',\n",
       " u'603885.XSHG',\n",
       " u'603993.XSHG']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取沪深300指数的所有股票\n",
    "get_index_stocks('000300.XSHG')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[u'000503.XSHE',\n",
       " u'002095.XSHE',\n",
       " u'002113.XSHE',\n",
       " u'002131.XSHE',\n",
       " u'002174.XSHE',\n",
       " u'002175.XSHE',\n",
       " u'002315.XSHE',\n",
       " u'002354.XSHE',\n",
       " u'002439.XSHE',\n",
       " u'002464.XSHE',\n",
       " u'002467.XSHE',\n",
       " u'002517.XSHE',\n",
       " u'002555.XSHE',\n",
       " u'002558.XSHE',\n",
       " u'002624.XSHE',\n",
       " u'300031.XSHE',\n",
       " u'300052.XSHE',\n",
       " u'300059.XSHE',\n",
       " u'300104.XSHE',\n",
       " u'300113.XSHE',\n",
       " u'300226.XSHE',\n",
       " u'300295.XSHE',\n",
       " u'300315.XSHE',\n",
       " u'300343.XSHE',\n",
       " u'300392.XSHE',\n",
       " u'300418.XSHE',\n",
       " u'300431.XSHE',\n",
       " u'300467.XSHE',\n",
       " u'300494.XSHE',\n",
       " u'300571.XSHE',\n",
       " u'600634.XSHG',\n",
       " u'600652.XSHG',\n",
       " u'600804.XSHG',\n",
       " u'600986.XSHG',\n",
       " u'603000.XSHG',\n",
       " u'603258.XSHG',\n",
       " u'603444.XSHG',\n",
       " u'603881.XSHG',\n",
       " u'603888.XSHG']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取互联网和相关行业的所有股票\n",
    "get_industry_stocks('I64')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### pandas和seaborn库的使用说明见Tutorials and Documentation（使用帮助）文件夹"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# 彩蛋"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "为了增加研究功能的体验，我们新增了如下两个彩蛋"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 回测和研究打通\n",
    "\n",
    "为了打通回测和研究功能，我们新增了两个回测API，回测过程中需要保存的文件，您可以保存到研究模块，也可以直接调用研究模块的文件。\n",
    "\n",
    "[详见API](/api#writefile-写文件)\n",
    "\n",
    "![回测和研究打通](https://image.joinquant.com/e5d5c80171a34b95598415cecd10e142)\n",
    "\n",
    "## 分享到社区\n",
    "\n",
    "为了便于交流，研究模块支持分享，您可以把notebook分享到社区，与大家交流。\n",
    "\n",
    "![分享到社区](https://image.joinquant.com/396c77e87917d681769771522a3ef57d)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "|"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}